var express = require('express');
var router = express.Router();
var conn = require('../dbs/user');
var fs = require('fs');
var http = require('http');
var mconn=require('../dbs/mysql');





/* GET home page. */
router.get('/', function (req, res, next) {

    mconn.query("select * from life_pic",function(data){
        res.send(data);
    });


});


router.get('/del/:id', function (req, res, next) {

    //res.send(res.locals.list.data);

    var sql="update  life_picdetails set uuid='11111111111111111' where  id=15760";
    mconn.execus(sql,function(count){

        res.send(JSON.stringify(count));

    })

});

module.exports = router;


